<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreateServerSpellMallInfoTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('server_spellMall', function (Blueprint $table) {
            $table->bigIncrements('id');
            $table->integer('server_id')->default(0)->comment('服务器id');
            $table->boolean('status')->default(false)->comment('状态：0不启用，1启用');
            $table->integer('spellPointRatio')->default(10)->comment('技能点兑换比例，多少积分兑换1点技能点');
    
            $table->text('spellTree0') ->comment('技能树_公共');
            $table->text('spellTree1') ->comment('技能树_战士');
            $table->text('spellTree2') ->comment('技能树_圣骑士');
            $table->text('spellTree3') ->comment('技能树_猎人');
            $table->text('spellTree4') ->comment('技能树_潜行者');
            $table->text('spellTree5') ->comment('技能树_牧师');
            $table->text('spellTree6') ->comment('技能树_死亡骑士');
            $table->text('spellTree7') ->comment('技能树_萨满');
            $table->text('spellTree8') ->comment('技能树_法师');
            $table->text('spellTree9') ->comment('技能树_术士');
            $table->text('spellTree11')->comment('技能树_德鲁伊');

            $table->timestamps();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('server_spellMall');
    }
}
